FaYTDRfmsOrig

EntityType | Independent
Logical Entity Name | FaYTDRfmsOrig
Default Table Name | FaYTDRfmsOrig
Logical Only | NO
Owner | dbo
Definition |
Note |

FaYTDRfmsOrig Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
YTDRecordIndicator |  | CHAR(1) | YES |
OriginationID |  | CHAR(23) | YES |
OriginalSSN |  | CHAR(9) | YES |
OrignalNameCode |  | CHAR(2) | YES |
AttendingCampusPellID |  | CHAR(6) | YES |
EDUse |  | CHAR(5) | YES |
InstitutionCrossReference |  | CHAR(13) | YES |
ActionCode |  | CHAR(1) | YES |
AcceptedNoPayments |  | CHAR(1) | YES |
AcceptedAwardAmount |  | CHAR(7) | YES |
AcceptedEstDisbDate1 |  | CHAR(8) | YES |
AcceptedEstDisbDate2 |  | CHAR(8) | YES |
AcceptedEstDisbDate3 |  | CHAR(8) | YES |
AcceptedEstDisbDate4 |  | CHAR(8) | YES |
AcceptedEstDisbDate5 |  | CHAR(8) | YES |
AcceptedEstDisbDate6 |  | CHAR(8) | YES |
AcceptedEstDisbDate7 |  | CHAR(8) | YES |
AcceptedEstDisbDate8 |  | CHAR(8) | YES |
AcceptedEstDisbDate9 |  | CHAR(8) | YES |
AcceptedEstDisbDate10 |  | CHAR(8) | YES |
AcceptedEstDisbDate11 |  | CHAR(8) | YES |
AcceptedEstDisbDate12 |  | CHAR(8) | YES |
AcceptedEstDisbDate13 |  | CHAR(8) | YES |
AcceptedEstDisbDate14 |  | CHAR(8) | YES |
AcceptedEstDisbDate15 |  | CHAR(8) | YES |
AcceptedEnrollmentDate |  | CHAR(8) | YES |
AcceptedLowTuitFlag |  | CHAR(1) | YES |
AcceptedVerificationFlag |  | CHAR(1) | YES |
AcceptedIncCode |  | CHAR(1) | YES |
AcceptedTransactionNumber |  | CHAR(2) | YES |
AcceptedEFC |  | CHAR(5) | YES |
AcceptedSecondaryEFC |  | CHAR(1) | YES |
AcceptedAcadCal |  | CHAR(1) | YES |
AcceptedPayMeth |  | CHAR(1) | YES |
AcceptedCOA |  | CHAR(7) | YES |
AcceptedEnrollmentStatus |  | CHAR(1) | YES |
AcceptedWeeksOfInstTime |  | CHAR(2) | YES |
AcceptedWeeksInProg |  | CHAR(2) | YES |
AcceptedHours |  | CHAR(4) | YES |
AcceptedHoursInProg |  | CHAR(4) | YES |
Unused |  | CHAR(22) | YES |
ScheduledPellGrant |  | CHAR(5) | YES |
StudentName |  | CHAR(26) | YES |
StudentCurrentSSN |  | CHAR(9) | YES |
StudentDateOfBirth |  | CHAR(8) | YES |
CPSVerification |  | CHAR(1) | YES |
YTDDisbursementAmount |  | CHAR(7) | YES |
BatchID |  | CHAR(26) | YES |
ProcessDate |  | CHAR(8) | YES |
Unused2 |  | CHAR(2) | YES |
DateAdded |  | DATETIME | YES |
DateLstMod |  | DATETIME | YES |
UserID |  | INTEGER | YES |
FaYTDRfmsOrigID |  | INTEGER | NO |
ts |  | TIMESTAMP/DATE | NO |

FaYTDRfmsOrig Keys

Key Name | Key Type | Keys
FaYTDRfmsOrig_FaYTDRfmsOrigID_U_C_IDX | PrimaryKey | FaYTDRfmsOrigID

FaYTDRfmsOrig Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

FaYTDRfmsOrig Check Constraints

Check Constraint Name | CheckConstraint

FaYTDRfmsOrig Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaYTDRfmsOrig | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaYTDRfmsOrig | NO |  |  |

FaYTDRfmsOrig Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaYTDRfmsOrig Data Movement Rules

Name | Type | Rule Text/Value